Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server


Creating a new empty OpenEdge database

The DataServer uses the empty OpenEdge database as a holder for the schema for your MS SQL Server database. The simplest way to create an empty OpenEdge database is to do it from the Data Administration tool, as described in this section. For information on other ways to create an empty OpenEdge database, see OpenEdge Data Management: Database Administration .

To create and connect an empty OpenEdge database from the OpenEdge Data Administration tool:

  1. Start the Data Administration tool.
  2. Select the Database Create option. The Create Database dialog box appears:
  3. Type the schema-holder name (for example, mssholder) in the New Physical Database Name field.
  4. Select the An EMPTY Database option.
  5. Choose OK. The following dialog box appears. By default, the name of the newly created data source appears in the Physical Name field:
  6. You do not have to provide any additional connection information. You can add connection parameters when you create the data source or edit connection information later. See the online help for a complete description of the Connect Database dialog box.

  7. Choose OK to connect the empty OpenEdge database and return to the Data Administration main window.

Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095